# coding: utf8


## table definition

db.define_table('twitter_favorite', 
    Field('twitter_id', 'integer', notnull=True, unique=True ),
    Field('twitter_created_at', 'datetime', default=request.now),
    Field('text', 'string', length=140, notnull=True, unique=True ),
    Field('user_name', 'string', length=50),
    Field('user_screen_name', 'string', length=50, notnull=True),
    Field('user_profile_image_url', 'string', length=100),
    Field('created_on', 'datetime', writable=False, default=request.now),
    Field('urls', 'list:string')
    )
    
db.define_table('twitter_usertimeline', 
    Field('twitter_id', 'integer', notnull=True, unique=True ),
    Field('twitter_created_at', 'datetime', default=request.now),
    Field('text', 'string', length=140, notnull=True, unique=True ),
    Field('user_name', 'string', length=50),
    Field('user_screen_name', 'string', length=50, notnull=True),
    Field('user_profile_image_url', 'string', length=100),
    Field('created_on', 'datetime', writable=False, default=request.now),
    Field('urls', 'list:string')
    )
    


db.define_table('fc', 
    Field('feature', 'string', length=100, notnull=True, unique=False  ),
    Field('category', 'string', length=20, notnull=True, unique=False  ),
    Field('count', 'integer', notnull=True, default=0),
    )
    
db.define_table('cc', 
    Field('category', 'string', length=20, notnull=True, unique=True  ),
    Field('count', 'integer', notnull=True, default=0),
    )
